<?php
/* --------------------------------------------------------------
   specials.php 2008-11-28 mb
   Gambio OHG
   http://www.gambio.de
   Copyright (c) 2008 Gambio OHG
   Released under the GNU General Public License (Version 2)
   [http://www.gnu.org/licenses/gpl-2.0.html]
   --------------------------------------------------------------


   based on: 
   (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
   (c) 2002-2003 osCommerce(specials.php,v 1.30 2003/02/10); www.oscommerce.com 
   (c) 2003	 nextcommerce (specials.php,v 1.10 2003/08/17); www.nextcommerce.org
   (c) 2003 XT-Commerce - community made shopping http://www.xt-commerce.com ($Id: specials.php 1292 2005-10-07 16:10:55Z mz $)

   Released under the GNU General Public License 
   ---------------------------------------------------------------------------------------*/
$box_smarty = new smarty;
$box_smarty->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');
$box_content = '';
// include needed functions
require_once (DIR_FS_INC.'xtc_random_select.inc.php');

//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {
	$fsk_lock = ' and p.products_fsk18!=1';
}
if (GROUP_CHECK == 'true') {
	$group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";
}

$random_product = xtc_random_select("select
                                           p.products_id,
                                           pd.products_name,
                                           pd.gm_alt_text,
                                           p.products_price,
                                           p.products_tax_class_id,
                                           p.products_image,
                                           s.expires_date,
                                           p.products_vpe,
				                           p.products_vpe_status,
				                           p.products_vpe_value,
                                           s.specials_new_products_price
                                           from ".TABLE_PRODUCTS." p,
                                           ".TABLE_PRODUCTS_DESCRIPTION." pd,
                                           ".TABLE_SPECIALS." s
										   where p.products_status = '1'
										   and p.products_id = s.products_id
                                           and pd.products_id = s.products_id
                                           and pd.language_id = '".$_SESSION['languages_id']."'
                                           and s.status = '1'
                                           ".$group_check."
                                           ".$fsk_lock."                                             
                                           order by s.specials_date_added
                                           desc limit ".MAX_RANDOM_SELECT_SPECIALS);

if ($random_product || $_SESSION['style_edit_mode'] == 'edit') {

	$box_smarty->assign('language', $_SESSION['language']);
	if ($random_product["products_id"] != '' || $_SESSION['style_edit_mode'] == 'edit') {
		$box_smarty->assign('box_content',$product->buildDataArray($random_product));
		$box_smarty->assign('SPECIALS_LINK', xtc_href_link(FILENAME_SPECIALS));

		// set cache ID
		 if (!CacheCheck()) {
			$box_smarty->caching = 0;
			$box_specials = $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_specials.html');
		} else {
			$box_smarty->caching = 1;
			$box_smarty->cache_lifetime = CACHE_LIFETIME;
			$box_smarty->cache_modified_check = CACHE_CHECK;
			$cache_id = $_SESSION['language'].$random_product["products_id"].$_SESSION['customers_status']['customers_status_name'];
			$box_specials = $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_specials.html', $cache_id);
		}

				$gm_box_pos = $coo_template_control->get_menubox_position('specials');

		$smarty->assign($gm_box_pos, $box_specials);
	}
}
?>